USE [JobBoard]
GO

/****** Object:  Index [IDX_CoverLetter_JobSeekerID]    Script Date: 07/21/2013 02:02:15 ******/
CREATE NONCLUSTERED INDEX [IDX_CoverLetter_JobSeekerID] ON [dbo].[CoverLetter] 
(
	[JobSeekerID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


USE [JobBoard]
GO

/****** Object:  Index [IDX_Resume_JobSeekerID]    Script Date: 07/21/2013 02:01:51 ******/
CREATE NONCLUSTERED INDEX [IDX_Resume_JobSeekerID] ON [dbo].[Resume] 
(
	[JobSeekerID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

USE [JobBoard]
GO

/****** Object:  Index [IDX_JobApplication_JobID]    Script Date: 07/21/2013 02:03:43 ******/
CREATE NONCLUSTERED INDEX [IDX_JobApplication_JobID] ON [dbo].[JobApplication] 
(
	[JobID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

USE [JobBoard]
GO

/****** Object:  Index [IDX_JobEducation_JobID]    Script Date: 07/21/2013 02:04:57 ******/
CREATE NONCLUSTERED INDEX [IDX_JobEducation_JobID] ON [dbo].[JobEducation] 
(
	[JobID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

USE [JobBoard]
GO

/****** Object:  Index [IDX_JobSkill_JobID]    Script Date: 07/21/2013 02:05:54 ******/
CREATE NONCLUSTERED INDEX [IDX_JobSkill_JobID] ON [dbo].[JobSkill] 
(
	[JobID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

USE [JobBoard]
GO

/****** Object:  Index [IDX_SubscriptionHistory_CompanyID]    Script Date: 07/21/2013 02:08:43 ******/
CREATE NONCLUSTERED INDEX [IDX_SubscriptionHistory_CompanyID] ON [dbo].[SubscriptionHistory] 
(
	[CompanyID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO





